Quarter To Date

Returns a set of members from the same level as the given member (siblings), beginning with the first sibling member and ending with the given member, constrained by the Quarter level in the Time dimension.

Syntax & Usage

QTD()

A PQL expression that returns a single member element. The member must exist in the data source - it cannot be a custom member. For the QTD function, choose a member from the dateKey hierarchy; the given member will be the last date in the list.

Example

The resulting set will include a list of dates from the start of the given quarter (Q4, 2010), up to and including the selected date (2010-11-01):

{QTD([data].[dateKey].[1288569600000])}